SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001715s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 920913 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 920913 [ RunTime:0.003636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810303,549443,448391,723410,1041043,520913,166240,416012,605334,77605,992491,361294,970693,61204,119510,797565,175406,452138,729103,165259,429937,174145,201595,607584,877765,751463,715102,155201,996394,88441,613501,648675,316280,64654,138185,254391,245249,494323,720079,268451,401117,210989,815959,150453,745266,593964,191840,482061,55101,946832,609247,734371,580499,174373,67860,59239,432269,400293,370539,383099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002857s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 920913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 920913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000729s ]