SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546627 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546627 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183740,155226,870651,1014183,51202,1019300,356871,210048,331928,919331,535026,232401,476804,523839,945300,21977,822662,218796,216905,120109,889557,668864,109503,860796,708715,144019,762005,568787,804092,490035,139214,788984,42909,165073,472053,157325,305671,985467,307237,498312,17636,91014,1017821,165941,500954,46600,466537,998782,232939,273561,287663,454381,485044,697626,863984,468471,44596,840460,53282,331913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546627 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546627 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]