SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001708s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041042 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041042 [ RunTime:0.004391s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (32044,442028,589938,42059,170763,188701,862820,413126,333725,925462,462915,175309,421517,261909,766294,168638,857114,239844,423380,396603,703941,59551,694110,1021905,382749,584665,977548,595784,45053,1020935,376136,264265,449460,669991,354064,842534,863182,491281,359631,233112,107210,308053,536373,365178,407861,1040977,617864,699131,158661,760398,996553,351011,414488,250499,294969,871686,859635,690836,974215,871046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041042 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041042 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]