SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043203 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043203 [ RunTime:0.003799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29690,403676,667306,387242,213739,636350,903254,144640,330013,968484,674639,568257,642757,930268,487593,613024,117860,957649,574018,747856,448692,740176,459686,899262,935020,847156,853521,309885,467346,392339,446953,67632,111085,18092,641365,536156,534638,178963,922039,1034853,515946,236474,569534,65287,286861,862199,261397,470843,450056,564967,130875,601668,240673,227484,602610,1014132,605411,552403,159084,327407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]