SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452028 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452028 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356575,687337,644686,1046399,706467,708111,514976,387962,96864,230272,725783,823985,224551,981434,717126,880432,19327,587596,323315,303878,645230,1037287,1013807,404207,949299,53263,489149,580580,177412,482449,229723,598532,927662,775679,657103,186833,1014867,965153,751565,900767,76429,880394,72514,110064,581096,369647,70698,249742,632620,100157,944792,35775,369729,224568,924013,281669,541464,898094,88696,1021457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]