SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 180495 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 180495 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10982,552580,631819,767993,1014463,891634,1038848,591652,1017465,360081,764243,350496,108640,484888,74937,542105,989135,495628,108698,475553,9156,174513,171247,100911,1042087,867392,385999,10804,225669,774202,350022,156670,147085,356738,55535,307923,145957,913222,983907,613235,82143,26238,988458,744375,389668,313369,865854,707739,900521,142756,500986,883051,830733,970318,36025,231977,908051,256312,1027800,394959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 180495 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 180495 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]