SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408451 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408451 [ RunTime:0.002148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37698,838026,486625,771449,598712,376879,610397,827415,155964,64102,455394,859188,491445,638991,2434,288725,506552,485043,538161,874575,457968,320679,482412,161604,148757,856474,895255,756082,702763,379434,479324,1012624,109534,61892,318917,513079,131523,463572,598870,658486,638634,689884,382583,776511,863079,99166,164941,960789,996921,423786,357118,824964,68898,676949,132901,881707,9069,590178,641832,862934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]