SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001928s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542308 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542308 [ RunTime:0.002369s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814308,645598,555904,282230,390107,1039063,1013850,476359,699543,143349,207792,121457,767785,875630,680364,259406,757951,207787,1044034,634088,347145,307944,50151,833196,757637,623998,45895,987068,1044158,49098,842852,706536,459316,1026426,919623,415430,881042,12893,691575,730221,1013277,575643,1040514,245021,640038,899900,176142,879034,240835,638243,227317,598426,537951,775324,393641,577406,486620,115739,927318,408194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]