SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517968 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517968 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (749841,1043394,128503,723796,422564,826156,524847,563292,173000,751102,378164,54902,979938,240043,205139,129783,312553,27996,778780,82650,100197,460644,629740,929536,800246,896229,764330,233554,708893,769979,308747,908379,91925,1033799,896246,497826,599287,896783,963181,890555,470474,112702,741450,721935,373868,278827,429592,942154,970659,758054,563949,112739,819905,384470,877667,155195,84776,904697,158037,801276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000779s ]