SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539595 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539595 [ RunTime:0.002129s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541081,969043,811550,762930,476042,220196,906739,193189,364056,285606,42212,422744,613432,442754,199160,354585,1004924,454248,1003373,590330,416438,176469,437883,925316,951671,346651,1008799,752521,944032,846888,566992,315630,459187,613834,201879,521274,454873,858474,675760,955839,1009906,465939,803992,900998,387653,619702,400917,456272,761040,61001,1007845,141431,874918,512462,511083,585565,518707,211429,719370,942970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539595 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539595 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]