SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424609 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424609 [ RunTime:0.002466s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (946746,846220,541443,375117,128357,331391,192484,1002203,513866,949706,197156,726388,412358,969874,6963,78193,908098,1001753,233579,89804,298475,958548,763670,935686,972641,38278,16893,810034,491996,886487,991466,336689,913594,636371,972039,279558,170938,535073,927063,659706,428210,1044731,955885,853426,844677,387036,73931,316776,757418,855930,140135,159779,313404,644652,701356,50031,814029,1043571,676991,306932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]