SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401263 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401263 [ RunTime:0.003456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527550,1011247,999618,566172,1048750,465262,110076,400009,921308,93981,1005984,1030655,386165,1021265,712398,856094,234422,1001805,680284,847046,255462,64927,682959,620764,406464,475102,872526,739334,1034196,413107,305892,795372,926301,852833,242274,991850,785596,13366,174513,1024016,418476,410842,19022,579033,463901,235355,13650,71727,237981,209151,19292,182843,70353,160244,273188,807140,646391,67900,512325,154470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]