SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001429s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048024 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048024 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478312,934669,978155,450419,573061,579000,444784,505700,931898,1020862,187272,76059,97699,494138,228353,772841,413243,281159,824062,1018013,399284,493120,929062,854844,156313,508480,365495,223548,286746,945334,646241,687515,743972,454001,772472,376233,872097,709001,795898,507419,1048122,22237,437698,997905,845573,480152,390433,815382,721005,494641,26329,100227,332688,99574,409174,243304,972505,38075,57818,561122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048024 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048024 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]