SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011524 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011524 [ RunTime:0.002491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (244014,803262,131234,785714,909645,764218,948843,251696,890771,895110,378686,1028125,763371,527752,578132,129903,566426,459076,1040963,729052,147398,741093,483808,512614,408093,939643,56533,542868,768259,356012,223565,237257,1027868,750865,530795,49959,319529,121969,859528,535999,427333,819992,162249,319353,991818,455695,458770,932222,138659,691576,236094,866093,907915,951266,306246,89120,998009,949230,439515,594814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011524 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011524 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000384s ]