SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 307518 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 307518 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (357918,281741,616390,265986,601832,563422,815854,905638,637171,222897,650026,980936,614134,766337,859721,15315,313528,305139,230661,510953,708989,380598,591561,947451,376574,841268,694497,932539,122147,718400,811163,523329,188393,21087,680697,55545,139589,18656,812527,940049,110566,116694,176613,952278,752166,760425,940457,1021831,40656,1004586,834021,1005029,993638,595970,250861,174270,96505,866018,684233,436177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 307518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 307518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]