SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002799s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017406 LIMIT 1 [ RunTime:0.001320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017406 [ RunTime:0.004428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120439,664526,499975,879311,600081,14289,624554,990458,488135,964982,970541,577018,485186,458353,900364,167688,350365,495806,972100,130282,626517,348704,991592,618142,436053,240346,671572,820279,23598,512320,331905,148546,441226,363723,495137,116838,656834,645803,860233,400872,103293,993790,1032813,210498,970552,514024,66515,757091,732363,194302,311353,88601,811396,123981,832688,411214,635541,128425,953284,1012046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001688s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001894s ]