SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043978 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043978 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984718,754922,637369,430889,982233,132398,646380,760326,216811,3231,545721,724757,132861,808374,166743,689301,745184,60728,269550,1046164,448584,391788,813942,666498,22975,402168,806620,135123,197441,476615,109570,1046394,558478,580698,115562,774049,450925,372979,28516,946380,1035342,805138,610678,191397,777481,110844,242568,400456,718180,860981,610249,220574,15496,218799,735869,597214,837830,317868,754044,39753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]