SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011018 LIMIT 1 [ RunTime:0.002257s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011018 [ RunTime:0.006663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515126,663380,791239,914671,142298,256149,280923,1007244,483637,37461,982585,371877,284464,613936,162688,828268,678868,862585,887642,217044,617820,409882,582380,877412,176647,82841,50999,307542,96127,713225,877443,340776,207064,267833,474341,594217,727433,294269,222903,231081,410946,42303,516436,456847,732484,532561,1016222,497403,33498,147683,644358,269568,957173,618386,147145,558736,891967,157227,858717,835543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002738s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001035s ]