SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001773s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563540 LIMIT 1 [ RunTime:0.001730s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563540 [ RunTime:0.004104s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912898,932991,432768,945799,323926,833940,732264,760619,309294,549427,1031554,781731,646625,604444,187585,1040952,776425,849347,490938,315772,226602,800704,138016,326231,1991,591916,796151,1024202,988339,190655,300916,139954,536974,804853,1014397,322014,89687,728788,888701,486016,41518,932684,439018,728001,115604,644472,985480,129500,581218,673209,13596,30156,726404,207592,942823,449943,601452,654329,365719,904993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]