SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501327 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501327 [ RunTime:0.001398s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31382,445461,206389,670901,256546,449718,634903,491170,823491,981841,999146,265447,63172,442431,7363,716290,1012933,206755,531583,788113,431928,834101,723098,130102,436337,972157,290473,473374,986641,513220,60571,752450,872184,941434,427078,703841,703751,772499,495104,241950,801637,136298,711671,320290,107347,262874,865195,491145,347440,810805,1037043,614215,95884,943293,321448,854170,478155,153453,770194,465690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000868s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]