SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003857s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010073 LIMIT 1 [ RunTime:0.003450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010073 [ RunTime:0.011889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568241,435726,71542,67495,729398,39680,74599,169312,364211,372413,720910,41164,835619,546841,672635,408126,795705,587141,688886,738982,560381,263041,201015,591386,1048177,868898,619393,1021056,188819,522742,794996,903865,54267,199332,653660,927697,76419,903322,487910,10810,40845,685980,765859,505906,603451,213540,463314,351852,700819,555994,437596,335186,369412,452932,1047008,702348,1024896,290913,287347,1008930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000791s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]