SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314404 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314404 [ RunTime:0.003244s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982819,758567,419159,368528,438124,417062,847898,1020458,356180,145481,866907,28398,503122,251941,974156,709566,594147,869783,909291,360010,51919,870556,181430,691651,51901,1003253,82035,956990,140341,377117,662470,437971,1039810,761485,696211,590697,715385,240936,200834,1021106,723607,1008165,679977,349593,569114,733271,276178,873578,59845,967586,1008506,373433,178507,792414,437584,687394,68860,288932,369384,800728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001719s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]