SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464241 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464241 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473588,1047408,858345,532634,533854,525073,331209,849869,112738,557736,563837,898945,704420,845215,291488,830183,128582,168345,878159,212885,604728,882193,720202,534112,534665,461199,6708,501120,1048040,953133,320354,589222,609833,1029783,434629,768318,255187,292332,440848,910795,853560,351076,206917,567778,681510,275745,743504,1013622,382553,386732,212778,440767,21385,973113,818318,846076,993228,985545,164420,844012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]