SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551299 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551299 [ RunTime:0.001997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010176,982644,834257,23048,120405,454169,375903,216054,574397,143722,790300,698181,627208,745395,145649,357521,321212,562066,729591,1629,591441,96496,818264,917931,912798,30316,449737,1041521,21894,675709,258175,60973,586068,653400,402310,93778,531405,104858,141778,41292,669741,729114,516666,347361,922665,5827,554265,846618,45657,493574,919126,15389,938139,1014188,380110,523772,175083,288587,978976,826197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]