SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003151 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003151 [ RunTime:0.002523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836899,418795,804028,884927,79990,423262,454424,132780,252514,851393,575046,70109,826837,374652,776542,132288,389241,296928,39261,461110,883678,448766,496772,257813,238957,738293,67923,319284,444979,573647,977664,962364,115151,916974,512117,708680,667610,284284,798974,487483,419555,817226,679880,414190,754158,49237,336576,272367,1023036,82138,619348,1036960,180562,781360,30928,1026118,1045802,317743,472774,266538) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]