SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519705 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519705 [ RunTime:0.003629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257161,284441,410320,389346,770522,738761,42540,292834,690377,143110,210626,858943,292911,112782,283050,340870,613049,874644,886424,1036289,764402,505313,999540,417860,194903,463243,499773,41209,362163,757738,519267,863684,57389,812432,450184,687709,138409,81010,194010,808733,202981,552999,860263,982507,129084,981143,117389,519976,828102,371130,415724,220368,857100,781618,783357,852882,280382,303542,533041,408260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519705 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519705 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]