SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 325222 LIMIT 1 [ RunTime:0.000601s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 325222 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843938,43999,370207,340383,606547,428108,515973,1040045,148685,217572,53080,1031312,675145,356183,50708,44076,949462,694295,884840,313026,4888,543968,597996,543709,1026133,503011,993495,555408,1003917,169518,768872,498776,823105,84868,117839,974874,896262,218872,28869,186086,65797,880232,749491,459085,721939,888865,332522,456905,1036534,890799,838527,481819,842034,390080,101372,527640,838660,893480,201062,619539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 325222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 325222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]