SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417961 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417961 [ RunTime:0.002024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308398,312365,280384,185556,1033082,568998,992026,139451,244877,198024,746641,720069,927092,875976,128946,410319,448203,67284,1018144,846547,530490,1041949,527453,488222,164187,808960,570770,957472,487445,769773,11609,105367,640560,448885,347047,881743,335197,496771,65318,42604,1013666,487409,752490,1039297,461091,533995,472428,877986,454314,321419,497800,716171,214780,189425,895045,519978,827960,855217,106438,518835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]