SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807204 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807204 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504163,437285,907669,515338,83834,779407,373857,373334,372938,143368,606183,918811,188791,179464,75172,291094,68261,784181,652296,226687,887116,575789,430486,299891,800164,592688,171431,542470,858586,266769,241083,71553,592361,621505,668254,975186,847731,661533,1027574,1002052,117583,709542,53671,70875,532566,47700,433830,249878,62919,224522,828380,766612,587692,18685,307152,7992,430405,5558,958978,807176) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]