SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550072 LIMIT 1 [ RunTime:0.000671s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550072 [ RunTime:0.002197s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (380097,418255,75325,750281,807203,146869,923036,471726,879584,67499,609629,625793,67065,443732,116644,9366,798156,229434,729293,363918,554201,136268,264431,653234,1047525,362221,400582,708352,460134,686605,527700,732982,947504,670265,6643,312254,846188,117003,34245,259272,4892,518033,1026386,423746,72364,360620,634972,117523,977772,483254,246289,604508,821768,997428,1006992,311169,244104,100869,537612,910939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]