SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318185 LIMIT 1 [ RunTime:0.000820s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318185 [ RunTime:0.002688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368756,329384,256310,798674,420111,531623,978402,400838,582001,184896,861511,273150,1042643,964401,497408,589570,317978,838611,788619,873273,462513,862055,711735,3733,596888,956109,202678,170459,753364,397337,23301,699411,269029,286564,695760,810829,1041749,240830,145520,593012,976603,573888,836869,402215,586035,787406,536064,531671,188300,292937,88817,218971,523324,1030749,755847,548215,305411,926495,280163,17069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001833s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000996s ]