SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 184188 LIMIT 1 [ RunTime:0.003228s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 184188 [ RunTime:0.002501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184683,523877,541910,21453,495506,387129,964475,914926,296145,110881,775953,749022,394148,361296,459176,818951,912287,326695,129534,36129,563709,209935,344109,12506,10066,806519,265555,648757,341384,760274,691554,75624,29450,626260,329839,366685,438813,41784,540895,654531,694878,180945,956814,149350,1026548,620130,957919,334268,321963,596042,951464,365575,677399,452369,263408,488504,955671,763000,893642,13258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 184188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 184188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]