SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440051 LIMIT 1 [ RunTime:0.000807s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440051 [ RunTime:0.002553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920024,658963,455587,177050,560991,573782,671790,640615,691426,687394,1015038,284726,679028,260627,371755,387826,636173,363045,535174,487915,112717,25248,68327,741458,430524,123263,823742,918115,185999,408390,153911,761165,561503,928916,958808,268659,814118,184282,608792,324541,14417,331119,37122,957236,356647,52436,185975,396168,157084,72507,534781,366316,600438,1012079,310719,813256,38938,635105,899948,615517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000796s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001790s ]