SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484902 LIMIT 1 [ RunTime:0.001550s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484902 [ RunTime:0.002301s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440023,50257,508651,241614,947390,721914,111280,703982,539969,828176,978351,707630,89888,919366,687795,484978,449888,306193,978467,211128,110559,944772,922321,161549,551571,332628,413339,639983,534983,677520,210859,274069,922531,807216,181059,220959,256959,473735,116384,261136,790310,667742,133422,126701,792440,373007,784683,11462,36437,595838,977862,283661,146135,429212,854770,328240,700308,73595,861236,718865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003771s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484902 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484902 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]