SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004754 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004754 [ RunTime:0.004645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337067,456301,636622,196617,955960,776311,301875,417124,241499,429446,508903,916413,516516,845856,111192,791411,808589,732885,121512,27533,223066,768980,45164,848592,700911,765059,982901,891992,20230,568841,657186,342441,229506,108235,947193,510983,107765,405121,492676,863137,579235,1000929,372784,584919,200790,302297,1043172,90424,655888,246375,49372,468398,444595,167984,857418,652143,879702,371333,826106,987383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004754 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004754 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]