SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529076 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529076 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126999,1040849,103230,1011474,871512,620528,110803,189526,265577,944416,210805,134269,649142,252461,636101,238122,106717,980042,850094,19187,729228,298100,978176,913322,500445,866633,638679,849773,388477,582254,594778,420843,495504,113921,556971,397399,418613,813998,471154,114404,697104,203933,389572,457610,1026837,93564,228246,231255,622949,150788,885574,67992,307694,13957,896601,533750,753107,774286,926224,285013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529076 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000758s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529076 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]