SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028288 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028288 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (695831,538121,958796,642066,297618,658017,639082,610710,917421,142167,504337,345098,314739,245739,256181,949951,219062,991312,757745,130654,244891,925141,714870,455174,897767,927345,463410,291479,287646,846743,1039065,975631,651605,306600,865332,40172,76559,420633,865784,423641,931134,254059,291499,673104,72001,906399,5731,633172,471390,1045905,549216,425356,74056,28121,872968,487023,670208,191389,836064,327380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028288 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028288 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]