SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 299791 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299791 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334141,843687,1040323,519206,606364,198641,571406,595952,383949,297803,1013158,994566,46975,1041002,118806,437606,345184,60949,121188,590517,944445,78963,32767,78313,275236,1000199,206537,417120,245432,489656,138371,268570,338117,334361,631163,632717,694881,796752,566841,435021,894439,301008,273367,281304,814938,779462,839792,459233,422905,191908,566552,517206,65630,777147,840311,898816,941723,319033,15267,764069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]