SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 644396 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 644396 [ RunTime:0.002604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289329,145658,14078,671015,491639,545428,457460,83070,607214,198466,571658,261286,563036,23118,783386,712347,678369,338063,965579,231180,246388,879552,220083,649884,452724,881036,480393,841112,454675,44347,146118,853977,187978,596229,774843,952184,962485,936963,938196,574054,129772,715190,342023,724878,1035899,1015119,261342,372872,657550,705306,932744,333096,866511,404311,415599,264789,168646,508754,779327,802928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 644396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 644396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]