SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481531 LIMIT 1 [ RunTime:0.000754s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481531 [ RunTime:0.002265s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (361262,954020,905963,131098,343324,281999,763502,351240,114075,177018,432739,487874,584576,634811,98214,742001,331737,282484,574535,822637,208479,408328,877286,490836,55608,536599,531490,807733,352229,63598,549834,852168,497586,744616,894393,647682,844680,945232,278221,300652,397479,434553,285602,1038728,62169,958451,390487,151379,309568,690434,123452,714268,1033007,147382,975215,190134,460422,197952,58570,39344) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]