SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503860 LIMIT 1 [ RunTime:0.000836s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503860 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393342,395245,898467,124635,934649,793604,363319,504251,52153,123407,359278,151695,461449,52127,720139,706496,581648,691436,640771,343539,437011,678140,821063,556483,194038,610746,358538,701537,219860,149564,566825,53259,483376,130978,296704,189129,415283,856808,88835,894787,280281,534158,202475,1001229,606654,355342,572323,971687,734552,1024671,60413,140951,376407,659192,280664,538610,136031,711489,957929,457377) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]