SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291360 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291360 [ RunTime:0.002123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44203,583407,374578,776072,334086,977532,244370,695761,1018733,10849,1033210,602425,668839,521678,833935,196534,231273,1021662,631010,258356,347758,392881,772370,484692,656184,228620,584490,17493,925834,539745,589096,255827,291796,164010,953710,619967,402767,354608,987378,58739,181381,896553,234786,577572,536398,875056,450588,186871,2987,41431,868502,271110,862703,178572,1046961,141952,414262,312045,245109,717951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291360 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291360 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000951s ]