SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505407 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505407 [ RunTime:0.001542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (800535,792522,1040132,525743,168511,948012,1051,580807,390457,17724,201456,606344,955398,195072,730777,418871,783669,954433,374197,190139,343829,523223,113456,996944,360716,23663,41525,718311,469746,983925,544552,509495,835905,762956,725720,673249,834695,935779,575057,731675,387132,737881,752348,253201,206205,169577,208838,952551,568761,750029,453577,755495,765507,473581,499620,551214,944127,757986,296867,494290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]