SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529928 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529928 [ RunTime:0.003728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185498,134670,11911,580525,349449,358627,73117,407786,415180,139131,766737,807481,710676,874826,747967,468446,98872,795696,975006,540698,715921,794450,295001,792440,579524,924294,971218,916268,476378,274204,597027,730383,680892,123598,888634,397537,579066,1024407,387232,358541,796478,702047,203393,963054,984581,331334,308695,458769,1006962,834117,612665,628811,751444,650793,979765,185341,346900,438689,573476,483600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001837s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]