SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103753 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103753 [ RunTime:0.002611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (567445,14750,149118,325553,182601,23187,335113,846710,544607,914713,277381,534180,1020748,872280,928222,32960,357344,540441,187895,1006663,961883,667437,242546,889491,365461,1013264,325376,804420,365622,272926,1031619,952604,809718,558241,912843,804323,707719,700783,49127,63399,422319,390185,777641,147050,125801,570818,600550,418644,282242,139395,294400,797560,846166,606915,691006,790615,287539,968194,441464,529747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]