SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508215 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508215 [ RunTime:0.001855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520854,201122,869036,86241,633864,313725,881940,191189,897028,575807,527829,366959,101055,875053,121813,34526,96698,494910,689269,550467,604890,1027792,640889,908999,214812,775030,506280,175104,925953,575423,493741,42489,48894,915086,966093,761327,871659,423040,280750,829234,837277,603625,853579,753173,511286,642673,898636,361433,604063,255881,35503,794621,839667,900026,993058,452858,214702,638666,783326,223826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]