SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003605s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425041 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425041 [ RunTime:0.002341s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030903,687411,199879,441059,229595,1040349,552599,222810,473620,72126,641358,1027827,256285,41406,311287,342563,485023,867260,435390,989145,329776,339027,832554,893371,734912,257435,363316,830917,778046,312013,203500,558162,868467,642708,414128,508885,660888,940909,1023758,582690,80619,871465,69429,600496,922175,709047,74065,49214,958903,1043382,152123,849313,7896,657436,682744,134142,810860,450776,681138,640055) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]