SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106310 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106310 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335417,703168,775993,207482,1001385,400050,525922,870638,199019,1019539,86493,160816,137236,371009,116597,834489,810096,262187,453054,1035793,131504,110751,330798,26857,139491,346481,126263,524102,559856,74143,58144,660633,241793,59857,1044429,529512,742128,624508,228742,212238,236197,643226,369450,155366,501104,912282,386333,731845,225840,269983,546301,660943,870014,39549,1016380,20764,806616,254456,559081,512411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]