SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410332 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410332 [ RunTime:0.007027s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318384,794510,933867,1043522,541912,185739,582112,424193,535348,818157,166558,647105,241654,312729,300590,388314,518086,568573,974575,178991,129905,677498,442931,308741,658108,674732,623669,167939,492724,1021713,15507,162288,433475,1006418,197961,1046016,295340,444080,600102,1041431,255008,424432,653818,135539,317686,997426,893987,906048,492689,171141,315423,904893,533110,175191,112010,351208,364142,695013,118953,87604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410332 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410332 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]