SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292517 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292517 [ RunTime:0.002519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (666444,834570,686702,277212,104249,184818,40323,291383,692517,400613,102818,875459,53417,361274,539268,185212,971038,181296,621065,120553,453722,718537,640221,1038965,743321,632736,549568,962087,317270,34531,628893,528115,75130,289270,823296,497802,187059,979684,556267,427413,546433,189385,112099,475565,380313,47925,410380,142415,591523,791165,168582,856529,830713,1000035,149311,539022,907939,551061,758398,485749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]