SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351714 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351714 [ RunTime:0.003228s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503046,1011137,310394,642105,812538,392233,176118,902171,259973,746146,187823,464846,745969,884964,713535,282244,953118,182687,15292,596715,18043,162763,384472,692326,379661,1047169,795087,326831,384793,724927,146814,6788,405996,708181,989390,193377,870209,584995,125347,621185,914598,857201,400070,636619,1007642,219859,675407,418372,537960,803487,410133,696624,825396,936625,719364,536086,1047714,835595,604052,966879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]