SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 930010 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 930010 [ RunTime:0.001594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240470,391612,615402,682807,187593,375952,822697,541890,421689,146157,470599,705397,904542,775,592094,1038012,840145,635201,546438,625667,844926,978668,545895,467666,346625,1013043,499471,872899,548873,127918,675259,448322,945504,42774,245636,369995,1008056,991410,826481,145427,775219,890460,874893,433071,564907,735417,101214,608137,1020148,815490,207732,682606,743948,416100,218583,734577,1048857,92848,19607,16215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 930010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 930010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]