SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194923 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194923 [ RunTime:0.001754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520757,72919,287020,1041701,604869,254166,688596,231903,1016768,285459,267500,349188,955996,212185,329004,791759,910759,162197,174905,538637,109307,49099,892944,348713,324319,151540,749449,962371,1007350,868165,573280,821711,65596,340110,378714,173099,420107,73622,167217,1040393,283738,242544,254527,824812,200715,457953,97024,255301,115150,97262,242379,1044243,840292,149010,504822,644128,1043118,189578,841922,733943) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000707s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005515s ]