SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501231 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501231 [ RunTime:0.003577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936228,833578,406207,679702,965306,407584,145753,221347,679445,163942,319627,564450,855502,190251,300745,62017,119276,310826,826469,1028438,600114,636289,870019,745848,986389,37377,894459,1006038,366306,510688,548421,409937,975611,178443,144785,631518,435893,502459,281530,323346,251928,1044263,561776,473525,861139,335925,272331,76983,421441,865336,787737,1000316,9406,766078,302033,642637,518453,601626,76738,898895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501231 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000811s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501231 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]