SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001510 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001510 [ RunTime:0.002438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275812,743208,226143,585213,771151,226432,628473,575102,593771,310878,1025278,612274,345823,470539,482954,834092,731413,95843,905627,893060,552119,236528,765300,462229,985967,157506,661209,457955,329102,38930,60692,847578,906814,1035565,570928,484214,127543,35991,247468,302854,656828,808292,970659,933417,677285,377402,572090,233456,464426,502136,690396,365431,194181,383537,220355,463883,1007645,510215,320257,782935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]