SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102014 LIMIT 1 [ RunTime:0.000535s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102014 [ RunTime:0.002031s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384986,414927,728494,803803,514987,864540,925268,374819,188098,579932,788732,319239,1027967,152527,499554,337921,651759,498242,1023520,708813,616211,639239,230173,196801,488689,610983,94289,217408,775159,173277,797376,682184,902114,982870,821004,866129,187263,291768,562689,128355,180204,970325,611385,132237,709767,736139,398150,48934,10978,345799,988851,492515,410174,533304,945170,387077,851809,262730,169444,172069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]