SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022423 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022423 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148055,595692,142991,688589,665568,320981,938803,420838,434609,830921,254232,484764,792181,442244,585363,157592,1015080,376839,511980,1023760,490547,9242,573482,698237,460978,797771,141520,394280,714871,853430,165798,650455,376424,543209,985730,106333,690568,908490,628797,590203,23046,443425,18473,436321,993038,884847,719684,572789,777772,264265,94492,193599,855641,973300,532964,733363,581757,1005183,291734,504912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]