SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494513 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494513 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470823,810730,335232,140947,421272,190385,499277,977030,190433,373463,449671,176947,903592,367085,121577,420198,280770,333563,877058,174145,425976,1046007,554232,191926,899914,317521,178098,906135,235373,841237,631505,945105,325113,337622,696947,497230,133034,60213,248263,764755,477376,478174,734086,623008,681954,273451,227977,779979,899697,1006006,458000,899817,253255,923407,795023,402024,61116,784908,976884,852276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003880s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]