SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045664 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045664 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200376,186384,707726,787126,748566,950878,284021,24747,358247,991844,711449,667982,928142,241560,376462,857330,1020088,294101,724848,758089,47197,510755,515452,906275,946060,1001647,833162,857191,832253,725841,45946,878226,519099,527677,377724,381106,318082,775078,423199,429368,1025668,205936,260160,754636,752507,287513,582738,614901,574996,226940,577084,536832,852522,692685,145238,794430,227782,635158,463703,881705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045664 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045664 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]