SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504856 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504856 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016128,169758,62596,836435,63194,459232,730546,992767,310142,872274,998541,809022,464232,962968,942111,262777,587285,855423,856221,350587,578038,484522,649339,381991,276395,347791,968936,966834,677415,640935,806578,359652,654027,875203,436945,511266,106759,132121,715742,858861,266500,977502,577491,627362,983375,22061,719489,979492,438259,450605,448521,1048487,516953,120084,679049,791185,1009602,223381,954049,505068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]