SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565402 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565402 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035911,548066,126187,418646,591947,603154,202016,547543,930003,728216,48654,233208,511962,334624,889180,29085,519939,16160,273771,273927,60409,15684,664571,635139,1005486,511873,1005049,99436,502596,629852,289286,767142,349279,991294,383289,70564,246569,1012909,230710,72640,1019992,1017100,366300,522011,55924,179111,774942,793199,94710,696205,10200,491314,970085,489568,59595,225517,307411,525636,504541,775405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565402 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565402 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]