SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534836 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534836 [ RunTime:0.005124s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72951,981934,457053,805011,673142,182768,793941,359340,118994,205213,582251,844975,262139,922776,615598,670930,237761,485302,989611,370356,529686,178809,1046159,309374,71946,791133,769385,555175,793466,936028,968772,1017548,497651,405833,404878,402064,256774,441624,13371,682262,673316,362952,495381,678981,907012,737276,455769,95534,145963,515577,965634,578709,1004180,470344,4564,721542,896935,544450,960534,841746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]