SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419102 LIMIT 1 [ RunTime:0.000481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419102 [ RunTime:0.002544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261837,388697,881678,572803,434371,258282,905767,572710,126218,546673,685119,813024,63294,683545,111451,152661,392445,443949,722073,916283,705330,362748,355820,485703,293392,792337,681066,228360,1033300,527765,819875,105466,869535,789594,1023716,31693,594857,701624,570686,802620,42141,276599,916170,603140,1047994,496505,918322,739752,783657,163530,866208,371567,645088,269075,873597,454828,1003208,159032,565622,906129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]