SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005744 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005744 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583585,248760,777155,586724,769505,187837,563971,415628,85668,54748,649930,539600,864510,625055,189299,832424,578467,609639,29303,162526,280707,141783,541536,951424,399386,446297,760879,726015,464578,176521,717299,999880,686376,259992,367137,313282,157056,719919,709776,998007,1044874,163011,412,1013097,1022713,202598,785347,376582,338365,273490,22944,550925,860422,632661,514167,227452,908976,64977,678504,542737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005744 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005744 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]