SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502478 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502478 [ RunTime:0.002573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298080,129922,1019501,523799,719912,619456,910256,898881,788430,851800,652159,202615,740966,519406,462977,114573,308989,159625,764332,98674,788756,329253,129193,498809,100459,277828,900659,1048512,762130,712421,448464,879341,663213,571700,441118,440403,892148,787787,376412,575059,832409,76394,176791,799682,194873,565480,206080,681294,233981,335174,816154,666627,199260,622702,293423,464094,104648,676099,467448,327686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]