SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402514 LIMIT 1 [ RunTime:0.000570s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402514 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470025,374840,911355,859984,102310,511573,38779,1017476,1032178,437238,175712,41406,456757,103939,647995,90860,89869,80641,1047331,180813,450226,616968,407803,718265,924021,717485,142403,338956,214861,1014948,941993,851154,165374,756939,443047,1032957,409546,285582,423152,724420,805607,928287,77376,105837,166514,859929,460997,792760,146320,572180,882710,825828,552142,461812,266357,794665,997309,886982,875279,532400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]